2016-02-24 - 24993 - Spec - SNC PO Push Job Enhancements #sncsup #SNCProject
SPECIFICATIONS
2016-02-24-Spec-SNC PO Push Enhancements.
Purpose
Change the PO Push Setup to avoid PO failure to SNC.
Admin Info
| Purpose |
SNC PO Push Enhancements |
| Requested By |
Jingsha |
| Spec Created By |
Adithya, Prudvi |
| Spec Created Date |
02/24/2015 |
| Spec QA by |
Adithya |
| Objects |
ZSNC_ECC_GETPO ZSNC_ECC_CMASTERDATA2 ZSNC_ECC_MASTERDATA |
| Document Status |
Complete |
Estimates
| Sl.No |
Activity |
Estimation in Hours |
| 1 |
Research |
|
| 2 |
Documentation |
08 |
| 3 |
Development/ Config |
32 |
| 4 |
Unit test in DEV |
24 |
| 5 |
Unit test in QUA |
|
| 6 |
Other activity |
|
| TOTAL |
64 |
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]Documents
[Attach any document(s) received for the requirement(s)]
SNC PO push_Initial Requirements.xls
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
| Sl. |
Change Details |
Requested By |
Requested On |
Notes if any |
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]Currently PO Push Job is run at 8 PM. Which is having 2 other job Dependencies which are Customer Master and Material Master CIF, having the dependencies few materials are missed to be sent to SNC before the PO Push Job is executed, hence few POs are not making it to SNC.
Here is the New SNC PO Push Process:
Step 1 Populate TVARVC table with both PO and Customer ID. PO ID will be used to feed the Material master program to get the correct material list, as well as the actual PO push. And the customer ID will feed the customer master data program.
Step 2 Customer master data program should have minimum change as the customer ID will be feed from TVARV.
Step 3 Material master data program will generate the necessary information based on PO list from step 1.
In Scope:
[List the activities to be included in scope]
Out of Scope:
[Out of scope activities]Manually Processed POs are not included in this PO Push Process
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Step 1 Create a new Custom Program which determine the list of SNC pos to be moved and places in table TVARVC.
Create a Program "ZSNC_PO_GET" which shall determine all the POs which are to be sent to SNC and update those POs and its corresponding customers (for POs which are TAS & TAB) in TVARVC table with variable Name: "ZSNC_ECC_PO" & "ZSNC_ECC_PO_CUSTOMER" respectively.
The Program shall remove all the earlier records which are there on the variable and update.
Go to Table NAST.
Give the Inputs:
Application : EF (Hard Code Value)
Message Type - ZSNC (Hard Code Value)
Created on - MM/DD/YYYY (Input Field)
Processing status - 0 (Input Filed)
Put these POs in TVARVC table, with a variant "ZSNC_ECC_PO"
Pass the same POs as input in EKKN and get the corresponding sales orders, pass the sales order in to Table VBPA
Get values for AG - Sold to & WE - Ship to Add these two customers in the TVARVC table with a Variant "ZSNC_ECC_PO_CUSTOMER"
Step 2 Change the existing Customer Master Program:
Change the Customer Master Program “ZSNC_ECC_CMASTERDATA2” so as the customer masters shall be taken as an input from TVARVC table with variable "ZSNC_ECC_PO_CUSTOMER"
and CIF those customers. Exclude the customer which is having the issue in forming queue in TVARVC table
Variable Name shall be the Input for the Program.
Step 3 Change the existing Material Master Program:
Change the Material Master Program “ZSNC_ECC_MASTERDATA” so as the selection of the Materials and Info records has to be done for those POs which are there in the table TVARVC with variable "ZSNC_ECC_PO".
Consider the POs which are there in the table TVARVC, and Pass those Pos in to EKKO to get Vendor Number and EKPO to get the Plant, Material & Inforecord for those POs and CIF these Master Data
Variable Name shall be the Input for the Program.
Step 4 Setup the variant for the PO Push job so as it Pushed the Pos from TVARVC table.
Test Plan
[List test scenarios/cases to be executed here]| Test ID |
Test Scenario |
Expected Results |
| POPUSH1 |
Step1 Create Few SNC POs and Run the Program ZSNC_PO_GET with date range as input (yesterday to today) |
The POs for which the message type ZSNC which are unprocessed has to be updated in TVARVC table with variable ZSNC_ECC_PO |
| POPUSH2 |
Step1 Do not create any POs and run the Program ZSNC_PO_GET with date range as input (yesterday to today) having no unprocessed POs |
The earlier POs which are there with the variable has to be removed and No POs have to be updated in the TVARVC table with the variable "ZSNC_ECC_PO" |
| POPUSH3 |
Step1 Execute the program once again after the the POs are updated in TVARVC Table before the messages of the PO are processed |
The POs which are updated in the TVARVC has to be replaced again. Similarly the Customers are also needs to be replaced. |
| POPUSH4 |
Step1 Execute the program having ZSNC messages of few POs processed and few not from the TVARVC Table |
The POs of which ZSNC messages are not processed shall be updated in TVARVC table and of whose ZSNC messages are processed shall not be updated in TVARVC. Similarly the Customers of the unprocessed POs shall be replaced/updated in the Table and customers of the processed POs shall not be updated. |
| POPUSH5 |
Step2 Execute the customer master program having customer master in TVARVC table |
All the customer masters have to be moved to SNC. |
| POPUSH6 |
Step2 Execute the customer master program having No Customer Master in TVARVC table |
No Customer Master have to be moved to SNC and the Job has to be finished. |
| POPUSH7 |
Step3 Execute the Material Master program having POs in TVARVC table |
All the corresponding Materials, Vendor, Plant & Inforecords of the POs has to be moved to SNC. |
| POPUSH8 |
Step3 Execute the Material Master program having No POs in TVARVC table |
No Material master data has to be moved to SNC and the Job has to be finished. |
| POPUSH9 |
Process Run All the steps from Step1 to Step 4 has to be executed as a Job With Newly Created POs With Changed POs With Deleted POs |
Having all the POs & Customer Master updated in the TVARVC table, the POs has to be moved to SNC. |
Solution Details
[Provide complete technical details for configuration or programming here]
Step1:
Develop a new custom Program "ZSNC_ECC_GETPO" to get list of POs from NAST table based on message type = 'ZSNC' and Unprocessed status = '0'. Get all POs from above condition and store in TVARVC table with variable name as ZSNC_ECC_PO.
Get customers for POs and store customers in TVARVC table with variable name ZSNC_ECC_PO_CUSTOMER.
Input of the Program Looks like:
Step2:
Changes done for program ZSNC_ECC_CMASTERDATA2 to skip application flies form directory and get data from table TVARVC .
Initially the input for above program is customer numbers from files in stored location in AL11 directory.
Now program has modified to get customer from table TVARVC with input as name = ZSNC_ECC_PO_CUSTOMER.
Input of the Program Looks like:
Step 3:
Changes done for program ZSNC_ECC_MASTERDATA to skip application flies form directory and get data from table TVARVC .
Initially the input for above program is PO numbers from files in stored location in AL11 directory.
Now program has modified to get POs from table TVARVC with input as name = ZSNC_ECC_PO.
Issues
[List Issues / Bugs identified in configuration or development]
Release Notes